Tabular Model - Incident Analysis
Contents
| Model Table | DW Source view (SQL Server) | BI Access View | Referenced Information Source | Recommended Access Type |
| INCIDENT ANALYSIS MEASURES | FACT_INCIDENT_CASE_TM | FACT_INCIDENT_CASE_BI | FACT_INCIDENT_CASE | On Line |
Corresponding Information Sources are described below. Detailed
infomation about Information Sources can be found in
About Information Sources
| Model Table | DW Source view (SQL Server) | BI Access View | Referenced Information Source | Recommended Access Type |
| INCIDENT ANALYSIS | FACT_INCIDENT_CASE_TM | FACT_INCIDENT_CASE_BI | FACT_INCIDENT_CASE | On Line |
| COMPANY | DIM_COMPANY_TM | DIM_COMPANY_BI | DIM_COMPANY | On Line |
| POSITION | DIM_POSITION_TM | DIM_POSITION_BI | DIM_POSITION | On Line |
| EMPLOYEE CATEGORY | DIM_EMPLOYEE_CATEGORY_TM | DIM_EMPLOYEE_CATEGORY_BI | DIM_EMPLOYEE_CATEGORY | On Line |
| EMPLOYMENT | DIM_EMPLOYMENT_TM | DIM_EMPLOYMENT_BI | DIM_EMPLOYMENT | On Line |
| ORGANIZATION CODE | DIM_ORGANIZATION_CODE_TM | DIM_ORGANIZATION_CODE_BI | DIM_ORGANIZATION_CODE | On Line |
| REPORTING PERIOD | DIM_BI_TIME_BI | DIM_BI_TIME_BI | DIM_BI_TIME | On Line |
| ORGANISATION STRUCTURE | DIM_STRUCT_ORGANIZATION_CODE_CURRENT_TM | DIM_ORGANIZATION_CODE_BI | DIM_ORGANIZATION_CODE | On Line |
| JOB | DIM_JOB_DETAILS_TM | DIM_JOB_DETAILS_BI | DIM_JOB_DETAILS | On Line |
The following table lists the relationships between tables and columns in the
model.
| Relationship: Table (column) - Table (column) |
| INCIDENT ANALYSIS (DIM_POSITION_ID) - POSITION (ID) |
| INCIDENT ANALYSIS (DIM_EMPLOYEE_CATEGORY) - EMPLOYEE CATEGORY (ID) |
| INCIDENT ANALYSIS (DIM_COMPANY_ID) - COMPANY (ID) |
| INCIDENT ANALYSIS (DIM_ORG_CODE_ID) - ORGANIZATION CODE (ID) |
| INCIDENT ANALYSIS (DIM_EMP_NO) - EMPLOYMENT (ID) |
| INCIDENT ANALYSIS (DIM_RPD_ID) - REPORTING PERIOD (ID) |
| INCIDENT ANALYSIS (DIM_ORG_CODE_ID) - ORGANISATION STRUCTURE (ID) |
| INCIDENT ANALYSIS (DIM_JOB_ID) - JOB (ID) |